﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[A_UPD_ClassificacaoActual]
	-- Add the parameters for the stored procedure here
	@IDUtilizador AS INT,
	@IDCampeonato AS INT,
	@Jogos AS INT,
	@Vitorias AS INT,
	@Empates AS INT,
	@Derrotas AS INT,
	@GM AS INT,
	@GS AS INT,
	@DifGolos AS INT,
	@Pontos AS INT
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	UPDATE [Apostas].[dbo].[A_ClassificacaoActual]
	SET [IDCampeonato] = @IDCampeonato
      ,[Jogos] = @Jogos
      ,[Vitorias] = @Vitorias
      ,[Empates] = @Empates
      ,[Derrotas] = @Derrotas
      ,[GM] = @GM
      ,[GS] = @GS
      ,[DifGolos] = @DifGolos
      ,[Pontos] = @Pontos
	WHERE IDUtilizador = @IDUtilizador AND IDCampeonato = @IDCampeonato
		
END